home *** CD-ROM | disk | FTP | other *** search
/ Developer Source 9 / developer source - volume 9.iso / orinf / feb97 / aronf110.gif < prev    next >
Graphics Interchange Format  |  1998-02-10  |  32KB  |  352x309  |  4-bit (16 colors)
Labels: text | screenshot | display | software | number
OCR: SOL Lab @013 select /+ rufe / company.name rom company, sales where company company_id = sales company_Id (*) land Salos period_id = 3 and sales,sales total > 1000 Execute Print Explain Help User jacott Close Select Statement 1-Nested Loops Outer 3. - [Table Access By Roved Scoll.sa'os - Rows: 1003 Tablespace: Users 22. Untair Ind ax Range Scan Scou sales pk (Company) )o. Pened_Id) - Distinct Keys 1003 Roid Per Keyi :, Tablespace. Tools Figure 10: A query using OUTER JOIN and its resulting explain plan.